Optimization of material delivery time analysis by using Visual Basic for applications in Excel

<p>In small and medium enterprises, huge numbers of reports are prepared regarding the procurement, planning, production etc on daily, weekly, monthly, quarterly yearly basis. If interval between preparation same report is longer then there greater probability that employee can forget procedure preparing report; thus it beneficial to automate these types especially when no cost required for automation. In way, material delivery analysis a kind which monthly basis as per employees` feedback they usually some steps formation; therefore, was chance mistake at end employee. Therefore, this automated minimize error time. All manual tasks were enlisted programmed automation by help VBA macros. For execution macros, userform designed in visual basic editor (in MS excel) consisted four command buttons macros called buttons` click. On pressing ‘ctrl + q’ used appear screen. Furthermore, comparison old methods conducted reflect best suitable method. The take 1.55 minutes be made manually. Comparison time both formation indicated suggested method took 70.86% less compared report.</p>